﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="sms_info_contact_info.aspx.vb" Inherits="webfinancegdrassign4.sms_info_contact_info" %>


 <%--Smart Money $aver Project for University of Herts--%>
 <%--Date: 01 December 2013--%>   
 <%--Version 1--%>
 <%--Project Brief Description - This is a Smart Money Saver asp.net product using VB.net. It is intended to be used by Smart Money Savers who want to make and save money and earn and save a certain amount to benefit--%>
 <%--Program Brief Description - This is the main Site.Master file. All change appear on all pages. This is a standard program from a default build from setting up the project in Visual Studio --%>
 <%--Changes - Added an image for the Smart Investor program / website --%>
 <%--Changes - Changed original Texts to 'Smart Money $aver ' --%>

 <%--Update 1 -  5th Jan 2014 - sms_info_contact_info.aspx enabled page to allow admin user to update,delete and select data from Table --%>


<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

        <hgroup></hgroup> class="title">
        <h1><br /></h1> 
        <h1>Edit Contact Information</h1> 

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource005" DataKeyNames="ID" AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" style="font-size: xx-small">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
            <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID"  />
            <asp:BoundField DataField="about_website" HeaderText="About Website" SortExpression="about_website" />
            <asp:BoundField DataField="contact_website" HeaderText="Contact Info" SortExpression="contact_website" />
            <asp:BoundField DataField="about_image1" HeaderText="Image1" SortExpression="about_image1" />
            <asp:BoundField DataField="about_image2" HeaderText="Image2" SortExpression="about_image2" />
            <asp:BoundField DataField="about_image3" HeaderText="Image3" SortExpression="about_image3" />
            <asp:BoundField DataField="about_image4" HeaderText="Image4" SortExpression="about_image4" />
            <asp:BoundField DataField="about_image5" HeaderText="Image5" SortExpression="about_image5" />
            <asp:BoundField DataField="about_image6" HeaderText="Image6" SortExpression="about_image6" />
        
        </Columns>



        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
        <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
        <RowStyle BackColor="White" ForeColor="#003399" />
        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
        <SortedAscendingCellStyle BackColor="#EDF6F6" />
        <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
        <SortedDescendingCellStyle BackColor="#D6DFDF" />
        <SortedDescendingHeaderStyle BackColor="#002876" />



    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource005" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString004 %>" ProviderName="<%$ ConnectionStrings:ConnectionString004.ProviderName %>" SelectCommand="   f" OldValuesParameterFormatString="original_{0}" ConflictDetection="CompareAllValues" InsertCommand="INSERT INTO [sms_info] ([about_website], [contact_website], [about_image1], [about_image2], [about_image3], [about_image4], [about_image5], [about_image6], [ID]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)">
        <InsertParameters>
            <asp:Parameter Name="about_website" Type="String" />
            <asp:Parameter Name="contact_website" Type="String" />
            <asp:Parameter Name="about_image1" Type="String" />
            <asp:Parameter Name="about_image2" Type="String" />
            <asp:Parameter Name="about_image3" Type="String" />
            <asp:Parameter Name="about_image4" Type="String" />
            <asp:Parameter Name="about_image5" Type="String" />
            <asp:Parameter Name="about_image6" Type="String" />
            <asp:Parameter Name="ID" Type="Int32" />
        </InsertParameters>
        </asp:SqlDataSource>
        <br />
        <br />

            <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="ID"
            DataSourceID="SqlDataSource005" AllowPaging="True" style="font-size: small">
            <Fields>
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ID" />
            <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID"  />
            <asp:BoundField DataField="about_website" HeaderText="About Website" SortExpression="about_website" />

            <asp:BoundField DataField="contact_website" HeaderText="Contact Info" SortExpression="contact_website" />
            <asp:BoundField DataField="about_image1" HeaderText="Image1" SortExpression="about_image1" />
            <asp:BoundField DataField="about_image2" HeaderText="Image2" SortExpression="about_image2" />
            <asp:BoundField DataField="about_image3" HeaderText="Image3" SortExpression="about_image3" />
            <asp:BoundField DataField="about_image4" HeaderText="Image4" SortExpression="about_image4" />
            <asp:BoundField DataField="about_image5" HeaderText="Image5" SortExpression="about_image5" />
            <asp:BoundField DataField="about_image6" HeaderText="Image6" SortExpression="about_image6" />
                <asp:CommandField ShowInsertButton="True" />
            </Fields>
        </asp:DetailsView>
</asp:Content>


